Page 68 - 2629_Devagiri_C-8

The need for databases is as follows: Amit Sen Amit Sen
Richa Tondon Richa Tondon
Reduction of data redundancy: It refers to unnecessary Deepak Patel Deepak Patel
duplication of data. A centralised database helps avoid this Nitish Reddy Nitish Reddy
Anil Gurang Anil Gurang
by storing only one version of the data. Amit Sen
Richa Tondon
Data sharing: It allows multiple users to access and
work on the same data simultaneously, facilitating

real-time collaboration.

Data security: It ensures data safety through security systems, user
roles and permissions, allowing only authorised users to access and

modify the data.

Data integrity: Data integrity ensures that data is accurate,
consistent and reliable. Databases use constraints to prevent errors,
such as disallowing negative quantities or verifying that a supplier
exists before processing an order.

Data backup: Data backup in databases means making a copy of the
database files so that you can restore your data if it gets lost, damaged
or corrupted. It is a safety measure to protect important information.

DATABASE MANAGEMENT SYSTEM (DBMS)

A Database Management System (DBMS) is a software that allows users to control the creation,
maintenance and use of a database. It performs the tasks of maintaining databases so that the

information is readily available. It helps to manage the data of different fields like banks, offices,
railways, airlines, etc. DBMS allows users to store, manage and organise all the data in a way that
makes it easy to find and use whenever they need it.

RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)

A relational database is a type of database that stores data in the form of tables. These tables are
structured with rows and columns and they can be related to each other through common fields
(keys) to enable the retrieval of related information. The software package that is used to handle
relational databases is known as the Relational Database Management System (RDBMS).

66
Premium Edition-VIII